USE [BMIG_MENSUAL_POST_CADENA]

 -- creating the store procedure
IF EXISTS (SELECT name 
	   FROM   sysobjects 
	   WHERE  name = 'WASP_M0009_SEGURO'
	   AND 	  type = 'P') 
	DROP PROCEDURE [dbo].[WASP_M0009_SEGURO]
GO

CREATE PROCEDURE [dbo].[WASP_M0009_SEGURO] AS
begin

      SELECT  cs.ppsuc
            , cs.ppcta
            , cs.ppoper
            , vs.ppimp11 AS cod_seg1
            , cs.ppimp11 AS val_seg1
            , vs.ppimp12 AS cod_seg2
            , cs.ppimp12 AS val_seg2
            , vs.ppimp13 AS cod_seg3
            , cs.ppimp13 AS val_seg3
            , vs.ppimp14 AS cod_seg4
            , cs.ppimp14 AS val_seg4
            , vs.ppimp15 AS cod_seg5
            , cs.ppimp15 AS val_seg5
            , vs.ppimp16 AS cod_seg6
            , cs.ppimp16 AS val_seg6
            , vs.ppimp17 AS cod_seg7
            , cs.ppimp17 AS val_seg7
            , vs.ppimp18 AS cod_seg8
            , cs.ppimp18 AS val_seg8
            , vs.ppimp19 AS cod_seg9
            , cs.ppimp19 AS val_seg9
      into	dbo.ingreso_produccion_seguros_ant      
      FROM  dbo.ingreso_produccion_valores_seguros_ant AS cs 
            CROSS JOIN dbo.ingreso_produccion_codigos_seguros_ant AS vs
      WHERE (cs.ppsuc = vs.ppsuc) 
            AND (cs.ppcta = vs.ppcta) 
            AND (cs.ppoper = vs.ppoper)
      ORDER BY cod_seg1
END
